rs.open "select top 1 len(love_article.username) as

来源:百度知道 编辑:UC知道 时间:2024/06/08 00:11:12
rs.open "select top 1 len(love_article.username) as a,love_article.id,love_main.photo_x from love_article join love_main on love_article.userid=love_main.id order by love_article.username desc",conn,1,1

大家帮我看看这句程序哪里错了?

错误提示:
Microsoft JET Database Engine 错误 '80040e14'

FROM 子句语法错误。

rs.open "select top 1 len(love_article.username) as a,love_article.id,love_main.photo_x from love_article join love_main on love_article.userid=love_main.id order by love_article.username desc",conn,1,1

中间的top 1len(*****)不要分开,会错